CREATE PROCEDURE [dbo].[asi_CreateSalesHistory]
@amount decimal(18,4),
@transDate datetime,
@sourceCodeKey uniqueidentifier,
@orderTypeKey uniqueidentifier,
@orderNumber nvarchar(50),
@responseMediaCode nvarchar(20),
@priceSheetKey uniqueidentifier,
@extendedCost decimal(18,4),
@warehouseKey uniqueidentifier,
@invType char(1),
@billToContactKey uniqueidentifier,
@shipToContactKey uniqueidentifier,
@soldToContactKey uniqueidentifier,
@orderDate datetime,
@productKey uniqueidentifier,
@qtySold decimal(18,4),
@undiscountedExtendedPrice decimal(18,4),
@uomKey uniqueidentifier,
@userKey uniqueidentifier,
@systemKey uniqueidentifier,
@accessKey uniqueidentifier,
@commissionPlanKey uniqueidentifier,
@salesTeamGroupKey uniqueidentifier,
@salesLocationKey uniqueidentifier,        /* 11/30/04 - pjr */
@isPledge bit,
@invoiceLineNumber int,
@invoiceNumber nvarchar(50)
AS
DECLARE @salesHistoryKey uniqueidentifier
DECLARE @glTypeDistribution int

SET @salesHistoryKey = NEWID()
INSERT SalesHistory(SalesHistoryKey, TransactionDate, OrderNumber, OrderTypeKey, OrderDate,
  InvoiceTypeCode, BillToContactKey, ShipToContactKey, SoldToContactKey, ProductKey, WarehouseKey,
  QuantitySold, ExtendedPrice, UndiscountedExtendedPrice, ExtendedCost, UomKey, SourceCodeKey,
  ResponseMediaCode, PriceSheetKey, CommissionPlanKey, SalesTeamGroupKey, SalesLocationKey,
  AccessKey, CreatedOn, CreatedByUserKey, SystemEntityKey, IsPledge, InvoiceLineNumber, InvoiceNumber)
VALUES(@salesHistoryKey, @transDate, @orderNumber, @orderTypeKey, @orderDate,
  @invType, @billToContactKey, @shipToContactKey, @soldToContactKey, @productKey, @warehouseKey,
  @qtySold, -1 * @amount, @undiscountedExtendedPrice, @extendedCost, @uomKey, @sourceCodeKey,  
  @responseMediaCode, @priceSheetKey, @commissionPlanKey, @salesTeamGroupKey, @salesLocationKey,
  @accessKey, GETDATE(), @userKey, @systemKey, @isPledge, @invoiceLineNumber, @invoiceNumber)

GO